Setting Login Permissions

In SQL Server 2005 or above, you can check Alter, Control, Impersonate or View Definition against the server login listed in Login to assign this server login to have that login permission. Multiple permissions can be granted. You can click on the checkbox to have more choices on the permission setting.

To set all permissions for a login, control-click the login and select Grant Selected, Grant Selected With Grant Option, Deny Selected or Revoke Selected option.